CGI

Author

Joseph H

1 Intoduction

Hello, I’m Joseph from Morocco.

Inspired by Hans Rosling’s TED Talk, I taught myself data scraping, analysis, and visualization.
This non-academic approach has given me a unique perspective, as reflected in my projects—though it also means I may require a thorough onboarding process to align with team standards.

I’m open to starting as an intern, either full-time or part-time. Regarding time zones, I’m in UTC+1, but I’m flexible and can adjust my schedule to accommodate the team’s needs.

Feel free to reach me at joseph.ergo@proton.me, and to visit my website for more projects josephelhaddad.github.io.

This custom report, generated from processing 1.4 TB of public data locally, aims to explore the workforce dynamics of a company—up to 2020.
Essentially, I am doing research on a company that does research.

2 About the project

The project came to life after realizing that web scraping doesn’t allow deep-level filtering—without consuming too much time.The irony is, this project itself took me about a month, but the final RDB contains more data than I could ever scrape.

The raw data was 1.4 TB in size and holds information previously scraped.
Processing was done on my local machine using Python, Polars, and DuckDB, following this workflow:
- Processed raw data into structured Parquet files using Polars.
- Transformed each Parquet file into mini RDBs using Polars.
- Merged all mini RDBs into one using DuckDB.
- Analyzed and filtered data to fit the current project.

Alt text

3 EDA

3.1 information technology and services indestry’s yearly new recruit count

3.2 cgi’s workforce status over the years

4 Workforce sample

4.1 Adrian Wagener

Job title: Werkstudent
Associated: True
Socials: https://linkedin.com/in/adrian-wagener-45b741134

4.1.1 Adrian Wagener’s working period at cgi

4.1.2 Gantt plot of Adrian Wagener’s experience

4.2 Afshin Rahimi

Job title: ****
Associated: True
Socials: https://linkedin.com/in/afshin-rahimi-chrp-7a071053

4.2.1 Afshin Rahimi’s working period at cgi

4.2.2 Gantt plot of Afshin Rahimi’s experience

4.3 Andreas Rosén

Job title: ****
Associated: True
Socials: https://facebook.com/andreas.s.rosen | https://linkedin.com/in/andreas-rosén-ba3a3015b

4.3.1 Andreas Rosén’s working period at cgi

4.3.2 Gantt plot of Andreas Rosén’s experience

4.4 Anki Johansson

Job title: ****
Associated: True
Socials: https://linkedin.com/in/anki-johansson-391979185

4.4.1 Anki Johansson’s working period at cgi

4.4.2 Gantt plot of Anki Johansson’s experience

4.5 Anne Delhaise

Job title: Consultant - business analysis, communication, training
Associated: False
Socials: https://linkedin.com/in/anne-laure-delhaise-624189b | https://linkedin.com/in/anne-delhaise-624189b | https://linkedin.com/in/--624189b

4.5.1 Anne Delhaise’s working period at cgi

4.5.2 Gantt plot of Anne Delhaise’s experience

4.6 Arto Laurila

Job title: ****
Associated: True
Socials: https://linkedin.com/in/arto-laurila-4815b31b4

4.6.1 Arto Laurila’s working period at cgi

4.6.2 Gantt plot of Arto Laurila’s experience

4.7 Aurore Félix

Job title: Assistante commerciale
Associated: True
Socials: https://linkedin.com/in/aurore-félix-782231140

4.7.1 Aurore Félix’s working period at cgi

4.7.2 Gantt plot of Aurore Félix’s experience

4.8 Aurélien Bernard

Job title: ****
Associated: True
Socials: https://linkedin.com/in/aurélien-bernard-7b1262bb

4.8.1 Aurélien Bernard’s working period at cgi

4.8.2 Gantt plot of Aurélien Bernard’s experience

4.9 Axel Bayle

Job title: Ingã nieur en technologie de l’information
Associated: True
Socials: https://linkedin.com/in/axel-bayle

4.9.1 Axel Bayle’s working period at cgi

4.9.2 Gantt plot of Axel Bayle’s experience

4.10 Ben Pijpers

Job title: Senior software developer
Associated: False
Socials: https://linkedin.com/in/ben-pijpers-756791170

4.10.1 Ben Pijpers’s working period at cgi

4.10.2 Gantt plot of Ben Pijpers’s experience

4.11 Carla Gomes

Job title: Assistente contencioso
Associated: True
Socials: https://linkedin.com/in/carla-gomes-null-580714190

4.11.1 Carla Gomes’s working period at cgi

4.11.2 Gantt plot of Carla Gomes’s experience

4.12 Carmen Macias

Job title: Analista funcional
Associated: True
Socials: https://linkedin.com/in/carmen-macias-69293a121

4.12.1 Carmen Macias’s working period at cgi

4.12.2 Gantt plot of Carmen Macias’s experience

4.13 Cert.Apm Angelo Paglione

Job title: Manager
Associated: False
Socials: https://linkedin.com/in/angelopaglione | https://linkedin.com/in/angelo-paglione-pmp-216798a

4.13.1 Cert.Apm Angelo Paglione’s working period at cgi

4.13.2 Gantt plot of Cert.Apm Angelo Paglione’s experience

4.14 Chaimaa Zahri

Job title: Assistante pmo
Associated: True
Socials: https://linkedin.com/in/chaimaa-zahri-89091518a

4.14.1 Chaimaa Zahri’s working period at cgi

4.14.2 Gantt plot of Chaimaa Zahri’s experience

4.15 Charles Herbelin

Job title: Amoa
Associated: True
Socials: https://linkedin.com/in/charles-herbelin-b1a9a7167

4.15.1 Charles Herbelin’s working period at cgi

4.15.2 Gantt plot of Charles Herbelin’s experience

4.16 Christopher Yip

Job title: ****
Associated: True
Socials: https://linkedin.com/in/christopher-yip-110639160

4.16.1 Christopher Yip’s working period at cgi

4.16.2 Gantt plot of Christopher Yip’s experience

4.17 Crisc Wilson

Job title: Senior security consultant
Associated: False
Socials: https://linkedin.com/in/jasoncwilson

4.17.1 Crisc Wilson’s working period at cgi

4.17.2 Gantt plot of Crisc Wilson’s experience

4.18 Crystal Roy

Job title: ****
Associated: True
Socials: https://linkedin.com/in/crystal-roy-7454a4164

4.18.1 Crystal Roy’s working period at cgi

4.18.2 Gantt plot of Crystal Roy’s experience

4.19 Cssbb Khairul Alam

Job title: Partner consultant
Associated: False
Socials: https://linkedin.com/in/alamkhairul

4.19.1 Cssbb Khairul Alam’s working period at cgi

4.19.2 Gantt plot of Cssbb Khairul Alam’s experience

4.20 Damien Conte

Job title: Ã tudiant en alternance
Associated: True
Socials: https://linkedin.com/in/damien-lo-conte

4.20.1 Damien Conte’s working period at cgi

4.20.2 Gantt plot of Damien Conte’s experience

4.21 Elliot Ward

Job title: Shrink
Associated: True
Socials: https://linkedin.com/in/elliot-ward-03a384175

4.21.1 Elliot Ward’s working period at cgi

4.21.2 Gantt plot of Elliot Ward’s experience

4.22 Eric Burkholder

Job title: Jadocs system analyst
Associated: False
Socials: https://facebook.com/eric.burkholder.12 | https://linkedin.com/in/eric-burkholder-718a8085

4.22.1 Eric Burkholder’s working period at cgi

4.22.2 Gantt plot of Eric Burkholder’s experience

4.23 Fabián Loidi

Job title: Analista orgã nico
Associated: True
Socials: https://linkedin.com/in/fabi%c3%a1n-salaverr%c3%ada-loidi-b3237620

4.23.1 Fabián Loidi’s working period at cgi

4.23.2 Gantt plot of Fabián Loidi’s experience

4.24 Fanny Chautan

Job title: Chargã e d’affaires
Associated: True
Socials: https://linkedin.com/in/fanny-chautan-825247152

4.24.1 Fanny Chautan’s working period at cgi

4.24.2 Gantt plot of Fanny Chautan’s experience

4.25 Felix Tomczak

Job title: It-projektleiter
Associated: True
Socials: https://linkedin.com/in/felix-tomczak-b2852719a

4.25.1 Felix Tomczak’s working period at cgi

4.25.2 Gantt plot of Felix Tomczak’s experience

4.26 Franã§Ois Langer

Job title: Conseiller de direction
Associated: False
Socials: https://linkedin.com/in/francoisbel

4.26.1 Franã§Ois Langer’s working period at cgi

4.26.2 Gantt plot of Franã§Ois Langer’s experience

4.27 Head Of Pmo Siddiqi

Job title: Director, pmo, it, business - various roles
Associated: False
Socials: https://linkedin.com/in/muzzafarsiddiqi

4.27.1 Head Of Pmo Siddiqi’s working period at cgi

4.27.2 Gantt plot of Head Of Pmo Siddiqi’s experience

4.28 Istqb-Ctfl Wexler

Job title: Project manager
Associated: False
Socials: https://linkedin.com/in/bryan-wexler-csm-istqb-ctfl-28b7184

4.28.1 Istqb-Ctfl Wexler’s working period at cgi

4.28.2 Gantt plot of Istqb-Ctfl Wexler’s experience

4.29 John Doe

Job title: Commercial
Associated: True
Socials: https://linkedin.com/in/john-doe-5642151a6

4.29.1 John Doe’s working period at cgi

4.29.2 Gantt plot of John Doe’s experience

4.30 José Marçal

Job title: Trainee
Associated: True
Socials: https://linkedin.com/in/josé-marçal-0428021a2

4.30.1 José Marçal’s working period at cgi

4.30.2 Gantt plot of José Marçal’s experience

4.31 Kenneth Stringfellow

Job title: Senior software developer
Associated: False
Socials: https://linkedin.com/in/kenneth-stringfellow-73b180157

4.31.1 Kenneth Stringfellow’s working period at cgi

4.31.2 Gantt plot of Kenneth Stringfellow’s experience

4.32 Lara Veerasammy

Job title: Senior consultant
Associated: False
Socials: https://linkedin.com/in/lara-veerasammy-0868a620

4.32.1 Lara Veerasammy’s working period at cgi

4.32.2 Gantt plot of Lara Veerasammy’s experience

4.33 Lu Leung

Job title: Technical design authority
Associated: True
Socials: https://linkedin.com/in/lu-lu-leung-b967708b

4.33.1 Lu Leung’s working period at cgi

4.33.2 Gantt plot of Lu Leung’s experience

4.34 Luca Primativo

Job title: Project manager
Associated: True
Socials: https://linkedin.com/in/luca-primativo-473264118

4.34.1 Luca Primativo’s working period at cgi

4.34.2 Gantt plot of Luca Primativo’s experience

4.35 Marcel Zuniga

Job title: Analista de service desk bilingue
Associated: True
Socials: https://linkedin.com/in/marcel-anderson-zuniga-82a60612b

4.35.1 Marcel Zuniga’s working period at cgi

4.35.2 Gantt plot of Marcel Zuniga’s experience

4.36 Mariana Barbosa

Job title: Agente de call center
Associated: True
Socials: https://linkedin.com/in/mariana-barbosa-b53aa7151

4.36.1 Mariana Barbosa’s working period at cgi

4.36.2 Gantt plot of Mariana Barbosa’s experience

4.37 Marie Coisnard-Simon

Job title: Stage en dã veloppement
Associated: True
Socials: https://linkedin.com/in/marie-coisnard-simon-a801a8152

4.37.1 Marie Coisnard-Simon’s working period at cgi

4.37.2 Gantt plot of Marie Coisnard-Simon’s experience

4.38 Maroua Lahlouhi

Job title: Stagiaire
Associated: True
Socials: https://linkedin.com/in/maroua-lahlouhi-900bb9a9

4.38.1 Maroua Lahlouhi’s working period at cgi

4.38.2 Gantt plot of Maroua Lahlouhi’s experience

4.39 Michael Oliver

Job title: Opã rateur applicatif
Associated: True
Socials: https://linkedin.com/in/michael-oliver-5987a5175

4.39.1 Michael Oliver’s working period at cgi

4.39.2 Gantt plot of Michael Oliver’s experience

4.40 Mickael Cataldo

Job title: Alternant
Associated: True
Socials: https://linkedin.com/in/mickael-cataldo-06723b177

4.40.1 Mickael Cataldo’s working period at cgi

4.40.2 Gantt plot of Mickael Cataldo’s experience

4.41 Mike Popov

Job title: Senior consultant
Associated: False
Socials: https://linkedin.com/in/mika1713 | https://linkedin.com/in/mike-popov-8160265

4.41.1 Mike Popov’s working period at cgi

4.41.2 Gantt plot of Mike Popov’s experience

4.42 Murat Kaymaz

Job title: ****
Associated: True
Socials: https://linkedin.com/in/murat-kaymaz-a5b846a2

4.42.1 Murat Kaymaz’s working period at cgi

4.42.2 Gantt plot of Murat Kaymaz’s experience

4.43 Nicolas Gil

Job title: Analyste programmeur
Associated: True
Socials: https://linkedin.com/in/nicolas-gil-325823194

4.43.1 Nicolas Gil’s working period at cgi

4.43.2 Gantt plot of Nicolas Gil’s experience

4.44 Nicolas Robert

Job title: Administrateur systã me senior
Associated: False
Socials: https://linkedin.com/in/nicolas-robert-794a55122

4.44.1 Nicolas Robert’s working period at cgi

4.44.2 Gantt plot of Nicolas Robert’s experience

4.45 Nils-Erik Johansson

Job title: It consultant
Associated: False
Socials: https://linkedin.com/in/nils-erik-johansson-93720727 | https://linkedin.com/in/nils-erik-johansson

4.45.1 Nils-Erik Johansson’s working period at cgi

4.45.2 Gantt plot of Nils-Erik Johansson’s experience

4.46 Pierre-Marc Gauthier

Job title: Conseiller en automatisation et programmeur analyste
Associated: False
Socials: https://linkedin.com/in/pierre-marc-gauthier-997b4480

4.46.1 Pierre-Marc Gauthier’s working period at cgi

4.46.2 Gantt plot of Pierre-Marc Gauthier’s experience

4.47 Pierre-Yves Houdet

Job title: Engineer
Associated: False
Socials: https://linkedin.com/in/pierre-yves-houdet-646b766

4.47.1 Pierre-Yves Houdet’s working period at cgi

4.47.2 Gantt plot of Pierre-Yves Houdet’s experience

4.48 Rahul Mk

Job title: ****
Associated: True
Socials: https://facebook.com/raul.mk | https://linkedin.com/in/rahul-mk-51b6a897

4.48.1 Rahul Mk’s working period at cgi

4.48.2 Gantt plot of Rahul Mk’s experience

4.49 Ranju Singh

Job title: ****
Associated: True
Socials: https://linkedin.com/in/ranju-singh-947364121

4.49.1 Ranju Singh’s working period at cgi

4.49.2 Gantt plot of Ranju Singh’s experience

4.50 Robert Greenlee

Job title: Network administrator
Associated: False
Socials: https://linkedin.com/in/robert-greenlee-14503641

4.50.1 Robert Greenlee’s working period at cgi

4.50.2 Gantt plot of Robert Greenlee’s experience

4.51 Sabrina Gosha

Job title: Call center representative
Associated: True
Socials: https://linkedin.com/in/sabrina-gosha-62252817a

4.51.1 Sabrina Gosha’s working period at cgi

4.51.2 Gantt plot of Sabrina Gosha’s experience

4.52 Sara Yazidi

Job title: Comptable financier
Associated: True
Socials: https://linkedin.com/in/sara-yazidi-70516319a

4.52.1 Sara Yazidi’s working period at cgi

4.52.2 Gantt plot of Sara Yazidi’s experience

4.53 Scrum Titus Sequeira

Job title: Contract - program manager : performance testing
Associated: False
Socials: https://linkedin.com/in/tsequeira

4.53.1 Scrum Titus Sequeira’s working period at cgi

4.53.2 Gantt plot of Scrum Titus Sequeira’s experience

4.54 Stéphanie Chauvet

Job title: Chef de projet
Associated: True
Socials: https://linkedin.com/in/stéphanie-chauvet-616520124

4.54.1 Stéphanie Chauvet’s working period at cgi

4.54.2 Gantt plot of Stéphanie Chauvet’s experience

4.55 Susanne Mugge

Job title: Serviceagent
Associated: False
Socials: https://linkedin.com/in/susannemugge | https://linkedin.com/in/susanne-mugge1302

4.55.1 Susanne Mugge’s working period at cgi

4.55.2 Gantt plot of Susanne Mugge’s experience

4.56 Suzette De Nouveaux Défis

Job title: Conseillã re, acquisition de talents ti
Associated: False
Socials: https://linkedin.com/in/suzettegravel

4.56.1 Suzette De Nouveaux Défis’s working period at cgi

4.56.2 Gantt plot of Suzette De Nouveaux Défis’s experience

4.57 Vag Krishna

Job title: Sap business objects consultant
Associated: True
Socials: https://linkedin.com/in/vag-krishna-a4288a39

4.57.1 Vag Krishna’s working period at cgi

4.57.2 Gantt plot of Vag Krishna’s experience

4.58 Xavier Delenclos

Job title: Dã veloppeur
Associated: True
Socials: https://linkedin.com/in/xavier-delenclos-5a38b3135

4.58.1 Xavier Delenclos’s working period at cgi

4.58.2 Gantt plot of Xavier Delenclos’s experience

4.59 Yahya Abdellaoui

Job title: Java-ingenieur
Associated: True
Socials: https://linkedin.com/in/yahya-abdellaoui-67b015197

4.59.1 Yahya Abdellaoui’s working period at cgi

4.59.2 Gantt plot of Yahya Abdellaoui’s experience

4.60 Youness Bouabdelli

Job title: Analyste fonctionnel
Associated: True
Socials: https://linkedin.com/in/bouabdelliyouness